package com.cy.pj.sys.dao;

import com.cy.pj.common.pojo.Node;
import com.cy.pj.sys.pojo.SysCategory;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;


@Mapper
public interface SysStateDao {
      /**
               * 查询所有部门以及部门的上级菜单信息
       * @return
       */
	  @Select("select c.*,p.name parentName from order_state c left join order_state p on c.parentId=p.id")
	  List<Map<String,Object>> findObjects();
	  
	  @Select("select id,name,parentId from order_state")
	  List<Node> findZTreeNodes();
}







